
//-------------------------
// Legislators as Lobbyists
// TABLE A5
//-------------------------

clear
use masterdata_taa.dta

by state, sort: egen totpetition = count(certified)
by state, sort: egen totapproved = sum(certified)
gen approved = (totapproved/totpetition)*100
by state, sort: gen tt = 1 if _n == 1
br state totpetition approved if tt == 1


